create sequence DATA_PLANPROJECT_seq
increment by 1
start with 100
nomaxvalue
nocycle;

create or replace trigger DATA_PLANPROJECT_trigger
before insert
on WISCO_DATA_PLANPROJECT
for each row
declare
newid number(18,0);
begin
select DATA_PLANPROJECT_seq.nextval into newid from dual;
:new.dpid:=newid;
end;

create sequence DATA_bianzhi_seq
increment by 1
start with 100
nomaxvalue
nocycle;

create or replace trigger DATA_bianzhi_trigger
before insert
on WISCO_DATA_bianzhi
for each row
declare
newid number(18,0);
begin
select DATA_bianzhi_seq.nextval into newid from dual;
:new.dbid:=newid;
end;

create sequence DATA_equip_seq
increment by 1
start with 100
nomaxvalue
nocycle;

create or replace trigger DATA_equip_trigger
before insert
on WISCO_DATA_EQUIP_INTRODUCTION
for each row
declare
newid number(18,0);
begin
select DATA_equip_seq.nextval into newid from dual;
:new.deid:=newid;
end;
